package com.example.bijiabao.mapper;

import com.example.bijiabao.entity.book;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

@Mapper
public interface BookMapper {
    @Select("SELECT * from book")
    List<book> getAllBook();
    @Select("SELECT * FROM book where classId =1")
    List<book> findbookById1( );
    @Select("SELECT * FROM book where classId =2")
    List<book> findbookById2( );
    @Select("SELECT * FROM book where classId =3")
    List<book> findbookById3( );
    @Select("SELECT * FROM book where classId =4")
    List<book> findbookById4( );
    @Select("SELECT * FROM book where classId =5")
    List<book> findbookById5( );
    @Select("SELECT * FROM book where classId =6")
    List<book> findbookById6( );
    @Select("SELECT * FROM book where classId =7")
    List<book> findbookById7( );
    @Select("SELECT * FROM book where classId =8")
    List<book> findbookById8( );




}
